Finding the exclusive records in a table

Question

Aryan Kumar · Answer

Sure, you can find the exclusive records in a table using the DISTINCT keyword and the
WHERE clause. The syntax is as follows:
SQL
SELECT DISTINCT column_name
FROM table_name
WHERE condition;
For example, the following SQL statement will find all exclusive records in the
products table where the price column is greater than 100:
SQL
SELECT DISTINCT price
FROM products
WHERE price > 100;
This will return a list of all unique prices in the products table where the price is greater than 100.
Here is an example of how to find the exclusive records in a table in MySQL:
SQL
CREATE TABLE products (
  id INT NOT NULL AUTO_INCREMENT,
  name VARCHAR(255) NOT NULL,
  price INT NOT NULL,
  PRIMARY KEY (id)
);
INSERT INTO products (name, price) VALUES
('Product 1', 100),
('Product 2', 200),
('Product 3', 300),
('Product 4', 400),
('Product 5', 500);
SELECT DISTINCT price
FROM products
WHERE price > 100;
This will return the following result:
200
300
400
500
As you can see, the DISTINCT keyword has returned all unique prices in the
products table where the price is greater than 100.
Here are some additional things to keep in mind when using the DISTINCT keyword:
The DISTINCT keyword can be used with any column.The DISTINCT keyword will only return unique values.You can use the WHERE clause to filter the results of the 
DISTINCT keyword.

forum

Finding the exclusive records in a table

Revati S Misra

Can you answer this question?

1 Answers

Liked By